UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtQlVTc85kgM2wWYPz1LnM4sBEQgVH42tF67icmXcJs='
WHERE
key_id = '7f7178a6619d4789e640fbbe74be0e0cc7033a35250f4aae29647627c3cdcc95'
AND (
token = 'xtQlVTc85kgM2wWYPz1LnM4sBEQgVH42tF67icmXcJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)