UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPxVZ2ClAAV12tWZVD1f4xyqWBq3NcxuauXpjG2Kqoo='
WHERE
key_id = 'cf99f647cd5ae1a4867feefb122f281ab3b993f62c36f8b7f6782c481b5520e5'
AND (
token = 'XPxVZ2ClAAV12tWZVD1f4xyqWBq3NcxuauXpjG2Kqoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)