UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UdG3UAfnjHlZ77xqEcBxcZbpSCG4lwZP45EAeDIouI='
WHERE
key_id = 'd4952f338e383ef89a4c2bbb293d6f4858da1c45123d4a7f011e41b28a20370d'
AND (
token = '9UdG3UAfnjHlZ77xqEcBxcZbpSCG4lwZP45EAeDIouI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)