UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JiaRKG3eTd0kG7OkZPclZC3HDcNUJtww579gms1U8T4='
WHERE
key_id = 'a4b3254d2ba7ffe6047c6ad5bd3ad8d3e500acd1af8e50e89e7f07c6179a74bc'
AND (
token = 'JiaRKG3eTd0kG7OkZPclZC3HDcNUJtww579gms1U8T4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)