UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0mz9ZnuXU2TQA+gvVmogUd+OPxPbPwqtlloz3s3zN8='
WHERE
key_id = '31977635c8d671606a06f18d0de15548b9097becfff0af1051e4fc82a6698ebf'
AND (
token = 'q0mz9ZnuXU2TQA+gvVmogUd+OPxPbPwqtlloz3s3zN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)