UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XvMnQmXOONNZu2HMHFupQbNeq/+X/S6qcQbSMUsU8E='
WHERE
key_id = '2ba663802a3836ff89874c0a4d2c4a00ab215bc935792043a935934a7a536ec0'
AND (
token = '4XvMnQmXOONNZu2HMHFupQbNeq/+X/S6qcQbSMUsU8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)