UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8D/MTHj+Sj6FZYfWcxbGLaavV5ptC1HjyxGOegC1M+8='
WHERE
key_id = '556a86c979fe6ab646484295b67bc35411ea63a31bf80b0379895e41f5e1c7fc'
AND (
token = '8D/MTHj+Sj6FZYfWcxbGLaavV5ptC1HjyxGOegC1M+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)