UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbL6/+eOKxgVTl0GiIHfbusSUf46Izvp7GYe3keDILM='
WHERE
key_id = 'cc0e12dfff16c0cfedcc77821d2a284b5e11fa3ab18f060f3e2a22d4c7f26fdc'
AND (
token = 'xbL6/+eOKxgVTl0GiIHfbusSUf46Izvp7GYe3keDILM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)