UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OuE9zjEaPbBLqjPJa1B4lxDMsV337857dWxl2ovyHrc='
WHERE
key_id = '8de1c0a4cce82a59b20ecfb929ee7a9ec6f836ea9e197f7d5f0b7f58c1f20f73'
AND (
token = 'OuE9zjEaPbBLqjPJa1B4lxDMsV337857dWxl2ovyHrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)