UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gD1nH7ETcXkpoT09qbsKdOHhLqm4JhplvNxbcfc2BD0='
WHERE
key_id = '17bf9b3e39253c6ca9b37c75116b5debf41a5bed6dce7193bf31f794869434e4'
AND (
token = 'gD1nH7ETcXkpoT09qbsKdOHhLqm4JhplvNxbcfc2BD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)