UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsJ+IWeyXJcSgB2SFTsJmHayOw8DFM6uL4q3fL9LHz4='
WHERE
key_id = '7dd2080ea71628d16c169e8f4b46eee1eaaf40e6b9049d02212eb4d0c90db37b'
AND (
token = 'BsJ+IWeyXJcSgB2SFTsJmHayOw8DFM6uL4q3fL9LHz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)