UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a2zY8604VqodhlSDP+cnumwqmyIfAxS3kZ9RzDO8zHA='
WHERE
key_id = '348ff57c61d09ed50a8108ebd86371f0bf0aab7d5c7151082ac9371ca41e8ec3'
AND (
token = 'a2zY8604VqodhlSDP+cnumwqmyIfAxS3kZ9RzDO8zHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)