UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NlmRwTVTDj0mdAcQTVRdCPLnKRFhAvcB0MQJip6kk+8='
WHERE
key_id = 'a5724b36d050843bf1644ec2e71469935886d4a71c3d03b8e8fba6f9a3aa6026'
AND (
token = 'NlmRwTVTDj0mdAcQTVRdCPLnKRFhAvcB0MQJip6kk+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)