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