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