UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KG/dfw4+5M+jpHd0ZBPhFHQ9xPBq7JbvkxUke0THbgs='
WHERE
key_id = '4aed1fd9cfcd4e575fd367beeb37f7de62329406645662ea2aadaaeef2afa5db'
AND (
token = 'KG/dfw4+5M+jpHd0ZBPhFHQ9xPBq7JbvkxUke0THbgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)