UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KOr0NN/LcHpRp37560mvIwxSl7hmOy0W8GaWrpz7mkk='
WHERE
key_id = '47ac4938231dd05b844690125c678098b1acc47e70337a40d57f78e60a6b9a3c'
AND (
token = 'KOr0NN/LcHpRp37560mvIwxSl7hmOy0W8GaWrpz7mkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)