UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VQvUz1JfcrDEBcPwczA+yoHipSODgC5RrroyjbV/neM='
WHERE
key_id = 'a992f890bc5cb25fa1a34ee3bcbf448750c55a4f67e2226ae1a71e19c3dfa176'
AND (
token = 'VQvUz1JfcrDEBcPwczA+yoHipSODgC5RrroyjbV/neM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)