UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCQO0A7pd0Z+oyNPujozj0p4cWdaSAtZRbFR1boYvtk='
WHERE
key_id = 'f4a9a728d8b001d9a903edb34acd1d059de3360e74d7625efc2defb282e84a63'
AND (
token = 'dCQO0A7pd0Z+oyNPujozj0p4cWdaSAtZRbFR1boYvtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)