UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKxxVSbkPo7xS/uChqpjvIL4GaKkwjBHczWsopb5Jsg='
WHERE
key_id = 'a742b42f9b5b91aba9ca4c41ebd0c05f093204ad158388af87c47221e9e13a31'
AND (
token = 'qKxxVSbkPo7xS/uChqpjvIL4GaKkwjBHczWsopb5Jsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)