UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QWXCFrfA5cUIaX5ir0WiEt35DvRbBZcq2wy5yvAiMyw='
WHERE
key_id = '95d19c5886f42c5e9a2dc97be7327ad2b35723461fcd788c94530926bbbcab2e'
AND (
token = 'QWXCFrfA5cUIaX5ir0WiEt35DvRbBZcq2wy5yvAiMyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)