UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7JWeJ08quWsHn/yJRS1qGkSiU+Stn4AhAXZHmJUCCw='
WHERE
key_id = 'e52a6e53196930692067cce03ca5d5019d8f6ae87a3dc0eac71fffbb4eeb4274'
AND (
token = 'w7JWeJ08quWsHn/yJRS1qGkSiU+Stn4AhAXZHmJUCCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)