UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gK3nivmK0+bb6CIdLxwNiTHh0hGxT4/IvgDzScEvE+o='
WHERE
key_id = '18a60e199ab9fc2006f564a42becb17be88a50a05119ae1eb3de868348285c8c'
AND (
token = 'gK3nivmK0+bb6CIdLxwNiTHh0hGxT4/IvgDzScEvE+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)