UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K5CfrCthY80WBVGWRAjJUc++NErK+VSwrR+ZkH9B6cc='
WHERE
key_id = '31110637d6f3116542f53fccff823a2da87b79f47ea55eca70a11576d09fd931'
AND (
token = 'K5CfrCthY80WBVGWRAjJUc++NErK+VSwrR+ZkH9B6cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)