UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cg6TWOkmjoSrHCDaOqnK6MiBfozfBoG3D/K3gW4LIkg='
WHERE
key_id = 'cbd7e56e70359f19281a3f64f3976574db932ed135b28141d8a1726a76f52117'
AND (
token = 'cg6TWOkmjoSrHCDaOqnK6MiBfozfBoG3D/K3gW4LIkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)