UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ip92GakJ4DiUgDJQ9xQellA7QLVrRtQQ/mccc/uJDHU='
WHERE
key_id = 'e99e96e58d2a4c7b61c6639d612a3ffd897ea001aa3df6c623b8ee35f12cf3bb'
AND (
token = 'Ip92GakJ4DiUgDJQ9xQellA7QLVrRtQQ/mccc/uJDHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)