UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXfoI4Au2K4aCjNx/oDagKjm4wMKnEywKocbL/9iRRY='
WHERE
key_id = '42e5e494fe8ecd531ab54b51b8c9f46837ba75aa281d05d2b4637ad503b9044c'
AND (
token = 'xXfoI4Au2K4aCjNx/oDagKjm4wMKnEywKocbL/9iRRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)