UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CuqOELCRqyUxm1NTEyvAceN5cjBBoChCwX4Yw7TQh4='
WHERE
key_id = 'bb4ac503701c944d94db22822cce9a4f67828a656851cb17cd1c5d53b9ac0e78'
AND (
token = '5CuqOELCRqyUxm1NTEyvAceN5cjBBoChCwX4Yw7TQh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)