UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZ3An3a2L/h3wEwhcQZKf83hCXnCmruyrDfN3ekvnEU='
WHERE
key_id = '32bcf9a539aea4dd335e396e37356a635a5041c135647e5d355367fff98e72d1'
AND (
token = 'pZ3An3a2L/h3wEwhcQZKf83hCXnCmruyrDfN3ekvnEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)