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