UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'af7jShOwlMSbBdsNmj5krU9/XbyD9rSEbsfUAkN4SuU='
WHERE
key_id = '3abb7c13e640bc6bf049c80ecb10f1fdcfea7ff8f7d7ca4bb40f51c52a79bd4c'
AND (
token = 'af7jShOwlMSbBdsNmj5krU9/XbyD9rSEbsfUAkN4SuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)