UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8y2abE4tRSCvYQYzoDur4Usw5hU8QG/1UyL9je6kaQ='
WHERE
key_id = 'b8f4bc810827e132620231edde81402cda5cfd4380c9651fb05c9b2ab4820a4a'
AND (
token = 'j8y2abE4tRSCvYQYzoDur4Usw5hU8QG/1UyL9je6kaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)