UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0IrJPow/eoU+PHvmARJy5J9yzZQTPZpvdSnvMOb6eqE='
WHERE
key_id = '20ba50965b4e808e13654bbab9b5fabd77e35a0aca4d94673850504b67abe4c6'
AND (
token = '0IrJPow/eoU+PHvmARJy5J9yzZQTPZpvdSnvMOb6eqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)