UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dW83PWbDiBvcWDijWk44A0EURvXUhxEGuVbZ9Vdz22s='
WHERE
key_id = '31eaea9df12624bc9cb67b1a626d39920cdeb72642f21c979219d25aa6def552'
AND (
token = 'dW83PWbDiBvcWDijWk44A0EURvXUhxEGuVbZ9Vdz22s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)