UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36wiKLW/PTIvfdqJgJATLLDyR30atobHsPN3hNwIySA='
WHERE
key_id = '5b46227362f466088937cf63ee9b78a73d249f5ae8b8b659265d2ea5d33ef32c'
AND (
token = '36wiKLW/PTIvfdqJgJATLLDyR30atobHsPN3hNwIySA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)