UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htGacH7pXl3dgvmOKVCXFf1ITBQbeHdhYKbz8VdZj5k='
WHERE
key_id = '0ebd7fb3fa23d6797969c25890a6b9743b2746cfff0b5d1a33bb6b9b1dc190ac'
AND (
token = 'htGacH7pXl3dgvmOKVCXFf1ITBQbeHdhYKbz8VdZj5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)