UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhNxZ/qqkbVPr4SGI24B9CXzM7WOeIdUf/of8/SFmVc='
WHERE
key_id = '3f9cfee743f60a888b9a02783039218cca67e4f56412b52e6db34cc03076c520'
AND (
token = 'BhNxZ/qqkbVPr4SGI24B9CXzM7WOeIdUf/of8/SFmVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)