UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JL0hLlnQfull5psrJrDPmp3HLlOR5aGjfMCS1VDaW0='
WHERE
key_id = '52b8b7f78f647b4717fd601dfd0115ae73244de7adddc17f6e40dccf512e6639'
AND (
token = '4JL0hLlnQfull5psrJrDPmp3HLlOR5aGjfMCS1VDaW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)