UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kv06uUvPfnzKaXEs7Uy/MHXmj9hgG8lLybnAerYSrXk='
WHERE
key_id = 'c029d98773f381f5e6ba8c3a753fb2c7be9b177fca830f28c1e7c63b6e92f4cc'
AND (
token = 'kv06uUvPfnzKaXEs7Uy/MHXmj9hgG8lLybnAerYSrXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)