UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36rPblQrE50mJG6vR4LDh+qgyb8AvzNonLL3/ZPARmU='
WHERE
key_id = 'cae7b62bd55a910816b2bc54813d756270579f3eab4daecee98a5dda69b8bcb9'
AND (
token = '36rPblQrE50mJG6vR4LDh+qgyb8AvzNonLL3/ZPARmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)