UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qtA8SthDO4VIL2Ta+i8FXDqA+XF2+8SlPgMmR9BeGac='
WHERE
key_id = 'e524cce7a97008c21fd8adc30555d4a55cbc97e30b2a0122b4ee2bd0a0b15428'
AND (
token = 'qtA8SthDO4VIL2Ta+i8FXDqA+XF2+8SlPgMmR9BeGac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)