UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4m2HAOrgXWjedP5WQH3yacbJhVSQzdXZopJslFmADSg='
WHERE
key_id = '7f3468593b74c412e5177972efa3a6407165b6a08feebd37efdb998161ad790a'
AND (
token = '4m2HAOrgXWjedP5WQH3yacbJhVSQzdXZopJslFmADSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)